OpenEdge Data Management:<br />SQL Reference UCASE

Release 10.1A: OpenEdge Data Management:
SQL Reference

UCASE

Returns the result of the argument character expression after converting all the characters to uppercase. UCASE is identical to UPPER, but provides ODBC-compatible syntax.

Syntax
UCASE ( char_expression ) 
Example

The example illustrates the UCASE function, returning columns from rows in the customer table where the last_name column, after being converted to uppercase, is equal to ‘SMITH’:
SELECT * 
    FROM customer 
    WHERE UCASE (last_name) = 'SMITH' ; 
Notes

The argument to the function must be of type CHARACTER.

The result is of type CHARACTER.

If the argument expression evaluates to NULL, the result is NULL.

A char_expression and the result can contain multi-byte characters. The uppercase conversion is determined by the case table in the convmap file. The default case table is BASIC.

Compatibility

ODBC compatible